-: Is there anything more beautiful than a line chart?
Within this lecture, we want to create, this type of chart.
If we go to our data, we have unemployment rate in the 1940s
in the United States,
and we have total men and women.
If you see this many data points, by many, I mean above 10,
you most likely will use the line chart.
Especially if this is continuous data,
that can be set over time.
I will select the entire data set we have here.
I'll go to my new slide,
and I will start it out by inserting a line chart.
Go to insert, go to line,
and you have a default line chart,
or we have the line chart with markers.
If you want the little dot, on each data point.
We have this many data points,
so I will prefer to have a clean line.
If I just paste my data into PowerPoint,
you can see we have a bunch of information.
It's very visible what's happening here,
it would get even more difficult,
if this chart would be a little smaller.
So what we can do to change that?
At first, I wanna show you,
you can filter out series, and time, from a chart.
I can click on the chart,
I can go to my filter options, and for example,
if the total value is the most important here,
I could possibly deselect the men,
deselect the women,
select apply,
and only this one series would remain.
You can do the same for categories,
if you would like to reduce the time displayed.
All right, beautiful.
We've learned something about filtering.
Then, I want you to add a percentage sign, to the Y axis.
We have percentage on the left,
but there is no percentage sign,
there is no percentage of total information on the left,
there is no title yet.
What you can do, you can actually click on this axis,
right click, format axis.
And apart from the normal axis options,
on the bottom, you have number.
This means, what is displayed here.
By default we have general,
and to not over complicate things,
you can format code, you can press space,
and after pressing space,
I can simply select percentage,
one time percentage, select add,
and no percentage will be displayed,
next to the general number.
Beautiful.
We completed task number three.
Task number four, recolor horizontal lines.
If you want to give this chart
a completely different feeling,
you can select these horizontal lines,
and they are just a part of the chart,
like anything else here.
You can right click, select format axis,
and format the grid lines.
I will select, instead of formatting just the axis,
I will actually format the grid lines,
and the grid lines have their normal line filling options.
On the line filling, I will select the color to be blue,
and you can see this chart,
has now a completely different vibe.
If you want that last line, to have the same color as well
You need to select the axis,
because the first line is always from the axis,
the rest are the grid lines.
I will select the axis itself,
with the dates,
go to the filling options,
and under the line options,
I will change this color to blue.
Beautiful.
Now all horizontal lines are blue.
I will end this first part here,
and let's continue editing our line chart
in the next lecture,
because the line chart is so beautiful,
we need to give it a little bit more attention.